package guoanmaker.operator.business.repository;

import java.util.Collection;
import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import guoanmaker.operator.business.model.OperatorSyspage;


public interface OperatorSyspageRepository extends JpaRepository<OperatorSyspage, String>, JpaSpecificationExecutor<OperatorSyspage>{
	
	
	List<OperatorSyspage> findBysidIn(Collection<String> sid);
	
    @Query("select s from OperatorSyspage s where s.sid=:sid")
    public  OperatorSyspage  selectBysid(@Param("sid")String sid);
    @Query("select s from OperatorSyspage s where s.pid=:pid order by s.sysnum asc")
    public List<OperatorSyspage>  findByPid(@Param("pid")String pid);

}
